The following example describes a typical reporting scenario wherein grouping on server can significantly reduce the amount of unnecessary data transferred from the database server.
Look in the bottom right corner of the Crystal Reports window and notice that 270 records are returned for this report.
Notice that 270 records are still returned for the report, even though the Detail records are hidden from view.
Now notice that only 72 records are returned for the report. The grouping (by Country) has been performed on the database server, and fewer records have been transferred to the report.
For instance, if you drill down on Australia, Crystal Reports quickly retrieves the seven records that make up the group.
By hiding the Details section of this report, you've created a summary report that's easy for users to navigate. Each user can first locate the Country with which he or she is concerned, and can then drill down to retrieve valuable details.
Moreover, by enabling the Perform Grouping on Server option, you've ensured that the initial processing is completed on the database server. Consequently, only the necessary records are transferred to the report.
For more information on server
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |